﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using DTO;
using System.Data.SqlClient;
using System.Data;
namespace DAO
{
    public class NGONNGUDAO
    {
        public DataTable Bangngonngu()
        {
            DataTable datatable = new DataTable();
            SqlConnection conn = DATAPROVIDER.ConnectSQL();
            string sql = "SELECT * FROM NGON_NGU";
            SqlDataAdapter sqldataadapter = new SqlDataAdapter(sql, conn);
            sqldataadapter.Fill(datatable);
            conn.Close();
            conn.Dispose();
            sqldataadapter.Dispose();
            return datatable;
        }
    }
}
